CREATE TABLE [dbo].[banque]
(
[id_banque] [int] NOT NULL IDENTITY(1, 1),
[code] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[adresse] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[account] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[contact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[tel] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fax] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[inttext] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[banque] ADD 
CONSTRAINT [PK_banque] PRIMARY KEY CLUSTERED  ([id_banque]) ON [PRIMARY]
GO
